CREATE EXTERNAL TABLE jms_dm.dm_sign_aging_summary_dt(
  sign_date string COMMENT '签收日期', 
  order_source_code int COMMENT '订单来源编码', 
  start_agent_code string COMMENT '始发代理区编码', 
  end_agent_code string COMMENT '目的代理区编码', 
  start_center_code string COMMENT '始发转运中心编码', 
  end_center_code string COMMENT '目的转运中心编码', 
  start_provider_id int COMMENT '始发省份id', 
  end_provider_id int COMMENT '目的省份id', 
  start_city_id int COMMENT '始发城市id', 
  end_city_id int COMMENT '目的城市id', 
  start_area_id int COMMENT '始发区县id', 
  end_area_id int COMMENT '目的区县id', 
  start_network_code string COMMENT '始发网点编码', 
  end_network_code string COMMENT '目的网点编码', 
  order_source_name string COMMENT '订单来源名称', 
  start_agent_name string COMMENT '始发代理区名称', 
  end_agent_name string COMMENT '目的代理区名称', 
  start_center_name string COMMENT '始发转运中心名称', 
  end_center_name string COMMENT '目的转运中心名称', 
  start_provider_name string COMMENT '始发省份名称', 
  end_provider_name string COMMENT '目的省份名称', 
  start_city_name string COMMENT '始发城市名称', 
  end_city_name string COMMENT '目的城市名称', 
  start_area_name string COMMENT '始发区县名称', 
  end_area_name string COMMENT '目的区县名称', 
  start_network_name string COMMENT '始发网点名称', 
  end_network_name string COMMENT '目的网点名称', 
  today_aging_sign_num bigint COMMENT '今天时效签收票数', 
  today_aging_sign_time decimal(20,0) COMMENT '今天时效签收总耗时', 
  yesterday_aging_sign_num bigint COMMENT '昨天时效签收票数', 
  yesterday_aging_sign_time decimal(20,0) COMMENT '昨天时效签收总耗时', 
  today_actual_sign_num bigint COMMENT '今天实际签收票数', 
  today_actual_sign_time decimal(20,0) COMMENT '今天实际签收总耗时', 
  yesterday_actual_sign_num bigint COMMENT '昨天实际签收票数', 
  yesterday_actual_sign_time decimal(20,0) COMMENT '昨天实际签收总耗时')
    COMMENT  '签收时效汇总表'
    PARTITIONED BY (dt STRING COMMENT '时间分区(yyyy-MM-dd)')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_sign_aging_summary_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );




